My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: Saved Search - Backlog of Sales Orders
Hi, I think that :- CASE WHEN {quantity}-{quantitybilled}>0 THEN 0 ELSE 1 END and test for this being 0 again would work. Kind regards, Steve1 -
Re: How to default a Subsidiary for transaction records
Hi, there are 2 aspects I see to this :- A requirement to add subsidiary "Y" to all the client / vendor records - a CSV import for the client-subsidiary relationship and vendor-subsidiary r…1 -
Re: Details to Integrate the ODBC user for TM1 System
Hi Matan, I find this a little puzzling because the explanation says "direct cloud-to-cloud ODBC" whereas 'DSN' and 'Description' sound like settings you would have loca…2 -
Re: Can I add the file attached link into saved search?
Hi, I have found that if I link to the table 'File...' and then use the field 'Name' I can achieve this. If there are multiple files attached then you will see multiple rows in th…2 -
Re: Custom Record - Excel export
Hi, I may begin to sound like a SuiteQL fanatic soon but using this tool you could write the SQL code to join up your custom tables and then using the 'Format results as' CSV option retriev…1
